home *** CD-ROM | disk | FTP | other *** search
- NOTE ML0300 - PRINT MAILING LIST FILE 9/21/84
- STORE 0 TO DESCR
- DO WHILE DESCR>4.OR.DESCR<1
- ERASE
- ?
- ?
- ? ' PRINT MAILING LIST FILE'
- ?
- ? ' 1 TO PRINT LIST IN REC ID SEQUENCE'
- ? ' 2 TO PRINT LIST IN ZIP and NAME SEQUENCE'
- ? ' 3 TO PRINT LIST IN ALPHABETIC SEQUENCE'
- ? ' 4 TO PRINT LIST "COMPANY" RECORDS ONLY ALPHABETIZED ON CONTACT NAME'
- ?
- ? ' 99 TO RETURN TO MAIN MENU'
- ?
- INPUT 'ENTER SELECTION 'TO DESCR
- IF DESCR=99
- RELEASE DESCR,CVAL
- RETURN
- ENDIF
- ENDDO
- ?
- ?
- ? 'ENTER VALUE IN CODES FIELD TO SELECT NAMES FOR LETTER'
- ACCEPT ' <cr> = select all names for printing ' TO CVAL
- IF CVAL=' ' .AND. LEN(CVAL)=1
- STORE ',' TO CVAL
- ELSE
- STORE ','+CVAL+',' TO CVAL
- ENDIF
- ?
- STORE 'Y' TO RESP
- @ 21,0 SAY 'CONTINUE WITH REPORT? (Y/N) ' GET RESP PICTURE '!'
- READ
- IF RESP#'Y'
- RELEASE RESP,DESCR,CVAL
- USE
- RETURN
- ENDIF
- USE &FDEV
- GOTO 1
- IF * .AND. RECID=0
- STORE INST TO HEAD
- SET HEADING TO &HEAD
- ENDIF
- ERASE
- SET TALK ON
- DO CASE
- CASE DESCR=2
- ? ' INDEXING FILE FOR REPORT. PLEASE WAIT.'
- INDEX ON ZIP+!(INST) TO MLI
- CASE DESCR=3
- ? ' INDEXING FILE FOR REPORT. PLEASE WAIT.'
- INDEX ON !(INST) TO MLI
- CASE DESCR=4
- ? 'BUILD REPORT FILE'
- COPY TO ML0300 FOR CP.AND. @(CVAL,CODES)>0
- ?
- ? 'INDEXING FILE FOR REPORT. PLEASE WAIT.'
- USE ML0300
- INDEX ON !(CONTACT) TO MLI
- ENDCASE
- SET TALK OFF
- ?
- ? 'PRINTING MAILING LIST FILE'
- ?
- ? 'NOTE: PRINT IS SET IN CONDENSED MODE. IF JOB IS INTERRUPTED,'
- ? ' RESET PRINT TO STANDARD MODE BY TURNING POWER OFF AND ON'
- SET CONSOLE OFF
- SET PRINT ON
- ? CONDENSE
- note mrs-g? CHR(27)+'5'+CHR(15)
- REPORT FORM ML0300 FOR .NOT. * .AND. @(CVAL,CODES)>0 TO PRINT
- ? STANDARD
- note mrs-g? CHR(27)+'5'+CHR(18)
- ?
- SET PRINT OFF
- SET CONSOLE ON
- USE
- SET HEADING TO
- RELEASE DESCR,CVAL,HEAD,RESP
- IF FILE('MLI.NDX')
- DELETE FILE MLI.NDX
- ENDIF
- IF FILE('ML0300.DBF')
- DELETE FILE ML0300
- ENDIF
- RETURN